﻿Create PROCEDURE [dbo].[proc_ManagementArea_Update]
	(
	@CompanyName nvarchar(50),
	 @Startletter nvarchar(50),
	 @CompanyNumber nvarchar(50),
	 @CompanyPhone nvarchar(50),
	 @CompanyFax nvarchar(50),
	 @CompanyAddress nvarchar(100),
	 @Zip nvarchar(10),
	 @ContactPerson nvarchar(20),
	 @ContactPhone nvarchar(20),
	 @ContactEmail nvarchar(50),
	 @WebAddress nvarchar(50),
	 @Products nvarchar(2000),
	 @Id int
	)
AS
	Update ManagementArea Set
	CompanyName=@CompanyName,
	Startletter=@Startletter,
	CompanyNumber=@CompanyNumber,
	CompanyPhone=@CompanyPhone,
	CompanyFax=@CompanyFax,
	CompanyAddress=@CompanyAddress,
	Zip=@Zip,
	ContactPerson=@ContactPerson,
	ContactPhone=@ContactPhone,
	ContactEmail=@ContactEmail,
	WebAddress=@WebAddress,
	Products=@Products
	Where Id=@Id
	RETURN
